ABSTRACT
The world is witnessing a pandemic of SARS-CoV2 infection since the first quarter of the twenty-first century. Ever since the first case was reported in Wuhan city of China in December 2019, the virus has spread over 223 countries. Understanding and predicting the dynamics of COVID-19 spread through data analysis will empower our administrations with insights for better planning and response against the burden inflicted on our health care infrastructure and economy. The aim of the study was to analyze and predict COVID-19 spread in Ernakulam district of Kerala. Data was extracted from lab data management system (LDMS), a government portal to enter all the COVID-19 testing details. Using the EpiModel package of R-mathematical modeling of infectious disease dynamics, the predictive analysis for hospitalization rate, percentage of patients requiring oxygen and ICU admission, percentage of patients getting admitted, duration of hospital stay, case fatality rate, age group and gender-wise fatality rate, and hospitalization rate were computed. While calculating the above-said variables, the percentage of vaccinated population, breakthrough infections, and percentage of hospitalization among the vaccinated was also taken into consideration. The time trend of patients in ICU showed men outnumbered women. Positive cases were more among 20–30 years, while 61–70 years age group had more risk for ICU admission. An increase in CFR with advancing age and also a higher CFR among males were seen. Conclusions: Analyzing and predicting the trend of COVID-19 would help the governments to better utilize their limited healthcare resources and adopt timely measures to contain the virus. © 2023, The Author(s), under exclusive license to Springer Nature Singapore Pte Ltd.
ABSTRACT
The world is witnessing a pandemic of SARS-CoV2 infection since the first quarter of the twenty-first century. Ever since the first case was reported in Wuhan city of China in December 2019, the virus has spread over 223 countries. Understanding and predicting the dynamics of COVID-19 spread through data analysis will empower our administrations with insights for better planning and response against the burden inflicted on our health care infrastructure and economy. The aim of the study was to analyze and predict COVID-19 spread in Ernakulam district of Kerala. Data was extracted from lab data management system (LDMS), a government portal to enter all the COVID-19 testing details. Using the EpiModel package of R-mathematical modeling of infectious disease dynamics, the predictive analysis for hospitalization rate, percentage of patients requiring oxygen and ICU admission, percentage of patients getting admitted, duration of hospital stay, case fatality rate, age group and gender-wise fatality rate, and hospitalization rate were computed. While calculating the above-said variables, the percentage of vaccinated population, breakthrough infections, and percentage of hospitalization among the vaccinated was also taken into consideration. The time trend of patients in ICU showed men outnumbered women. Positive cases were more among 20–30 years, while 61–70 years age group had more risk for ICU admission. An increase in CFR with advancing age and also a higher CFR among males were seen. Conclusions: Analyzing and predicting the trend of COVID-19 would help the governments to better utilize their limited healthcare resources and adopt timely measures to contain the virus. © 2023, The Author(s), under exclusive license to Springer Nature Singapore Pte Ltd.
ABSTRACT
The Covid-19 pandemic presented a vast array of challenges for professors and students the world over. As we navigate Covid's long tail, many challenges remain. Those challenges - nasty as they are - can be recast in a constructive light and imbued with pedagogical significance as practical, common-ground motivational tools for teaching topics in data management. The author has done just that. In addition to teaching on full-time faculty in the Computer Science department at Marist College, he was a key member of their Covid-19 screening team. After designing and implementing data management systems for generating representative samples of the college population for surveillance testing, results tracking, and compliance monitoring, he used those experiences in new, hands-on ways to integrate data management theory with real-world practice in his classes. This experience report - wherein the author explains this journey and notes lessons learned - is an example of how, even once this pandemic has receded fully into the past, experiences like these can provide opportunities for educators to incorporate timely topics into their data management courses. © 2022 ACM.